www.gusucode.com > wxApp PHP版微信小程序CMS系统 v1.0PHP源码程序 > wxApp PHP版微信小程序CMS系统 v1.0/wxAppCMS_v1.0.0/wxAppCMS_v1.0.0/app/comment/comment.admincp.php

    <?php
/**
* iCMS - i Content Management System
* Copyright (c) 2007-2017 iCMSdev.com. All rights reserved.
*
* @author icmsdev <master@icmsdev.com>
* @site https://www.icmsdev.com
* @licence https://www.icmsdev.com/LICENSE.html
*/

class commentAdmincp{
    public function __construct($appid=null) {
        $this->appid = iCMS_APP_COMMENT;
        $appid && $this->appid = $appid;
        // $_GET['appid'] && $this->appid = (int)$_GET['appid'];
        $this->id    = (int)$_GET['id'];
    }
    public function do_config(){
        configAdmincp::app($this->appid);
    }
    public function do_save_config(){
        configAdmincp::save($this->appid);
    }
    public function do_iCMS($appid=0){
        $_GET['appid'] && $appid = (int)$_GET['appid'];
        category::$appid = $appid;

        $sql = "WHERE 1=1";
        $appid && $sql.= " AND `appid`='$appid'";
        $_GET['iid']          && $sql.= " AND `iid`='".(int)$_GET['iid']."'";
        isset($_GET['status']) && $sql.= " AND `status`='".$_GET['status']."'";
		if($_GET['cid']){
            $cid = (int)$_GET['cid'];
            if(isset($_GET['sub'])){
                $cids  = categoryApp::get_cids($cid,true);
                array_push ($cids,$cid);
                $sql.=" AND cid IN(".implode(',', $cids).")";
            }else{
                $sql.=" AND cid ='$cid'";
            }
        }
		$_GET['userid']&& $sql.= " AND `userid`='".(int)$_GET['userid']."'";
		$_GET['ip']    && $sql.= " AND `ip`='".$_GET['ip']."'";
        if($_GET['keywords']) {
            $sql.="  AND CONCAT(username,title) REGEXP '{$_GET['keywords']}'";
        }

        $maxperpage = $_GET['perpage']>0?(int)$_GET['perpage']:20;
        $total		= iCMS::page_total_cache("SELECT count(*) FROM `#iCMS@__comment` {$sql}","G");
        iUI::pagenav($total,$maxperpage,"条评论");
        $rs     = iDB::all("SELECT * FROM `#iCMS@__comment` {$sql} order by id DESC LIMIT ".iUI::$offset." , {$maxperpage}");
        $_count = count($rs);
    	include admincp::view("comment.manage");
    }
    // function do_article(){
    // 	$this->do_iCMS(iCMS_APP_ARTICLE);
    // }
    public function do_manage($appid=0){
    	$this->do_iCMS($appid);
    }
    /**
     * [查看评论回复]
     * @return [type] [description]
     */
    public function do_get_reply(){
    	$this->id OR exit("请选择要操作的评论");
        $comment = iDB::row("SELECT * FROM `#iCMS@__comment` WHERE `id`='$this->id' LIMIT 1");
        empty($comment) && exit('<div class="claerfix mb10"></div>评论已被删除');
        echo nl2br($comment->content);
        echo '<div class="claerfix mb10"></div>';
        echo '<span class="label">'.get_date($comment->addtime,'Y-m-d H:i:s').'</span> ';
        echo '<span class="label label-info"><i class="fa fa-thumbs-o-up"></i> '.$comment->up.'</span>';

    }
    public function do_del($id = null,$dialog=true){
    	$id===null && $id=$this->id;
    	$id OR iUI::alert('请选择要删除的评论!');
    	$rs = $this->get($id);
        $this->del($rs);
        $dialog && iUI::success('评论删除完成','js:parent.$("#id-'.$id.'").remove();');
    }

    public function do_batch(){
        $idArray = (array)$_POST['id'];
        $idArray OR iUI::alert("请选择要操作的评论");
        $ids     = implode(',',$idArray);
        $batch   = $_POST['batch'];
    	switch($batch){
    		case 'dels':
				iUI::$break	= false;
	    		foreach($idArray AS $id){
	    			$this->do_del($id,false);
	    		}
	    		iUI::$break	= true;
				iUI::success('评论全部删除完成!','js:1');
    		break;
		}
	}
    public function do_update(){
        if($this->id){
            $data = iSQL::update_args($_GET['_args']);
            $data && iDB::update("comment",$data,array('id'=>$this->id));
            iUI::success('操作成功!','js:1');
        }
    }
    public static function get($id=0,$userid=null){
        $sql = "`id`='".(int)$id."'";
        $userid===null OR $sql.= " AND `userid` = '" . (int)$userid . "'";
        return iDB::row("
            SELECT *
            FROM `#iCMS@__comment`
            WHERE {$sql}
        ");
    }
    public static function del($comment){
        iDB::query("
            DELETE FROM `#iCMS@__comment`
            WHERE `id` = '$comment->id';
        ");
        iPHP::callback(array('apps','update_count'),array($comment->iid,$comment->appid,'comments','-'));
        iPHP::callback(array('user','update_count'),array($comment->userid, 'comments','-'));
    }
    public static function delete($iid,$appid){
        iDB::query("DELETE FROM `#iCMS@__comment` WHERE iid='$iid' and appid='$appid'");
    }
    public static function _count(){
        return iDB::value("SELECT count(*) FROM `#iCMS@__comment`");
    }
}